Q: libocijdbc10.so could not be found for OCI datastore

"When adding an OCI datastore, I would get a message that libocijdbc10.so could not be found in the java.library.path (and another one). The directory which contains that "so" does exist in the LD_LIBRARY_PATH (does Tomcat pick that up?)."

Answer

Set the environment for Tomcat appropriately:

export ORACLE_HOME=/opt/oracle/product/10.1.0/Db_1
export
CLASSPATH=$ORACLE_HOME/jdbc/lib/ojdbc14.jar:$ORACLE_HOME/jdbc/lib/orai18n.jar:$ORACLE_HOME/jdbc/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

The last setting depends on the system, this is for SuSe Linux. Sometimes it is LD_PATH or SH_LIB_PATH etc.